﻿CREATE TABLE [dbo].[InfoContact] (
    [IDInfoContact]   INT           IDENTITY (1, 1) NOT NULL,
    [Telefon]         VARCHAR (50)  NULL,
    [Mobil]           VARCHAR (50)  NULL,
    [TelefonPersonal] VARCHAR (50)  NULL,
    [Fax]             VARCHAR (50)  NULL,
    [Email]           VARCHAR (150) NULL,
    [YMID]            VARCHAR (50)  NULL,
    [WebSite]         VARCHAR (150) NULL,
    [IDContact]       INT           NULL,
    CONSTRAINT [PK_InfoContact] PRIMARY KEY CLUSTERED ([IDInfoContact] ASC),
    CONSTRAINT [FK_InfoContact_Contact] FOREIGN KEY ([IDContact]) REFERENCES [dbo].[Contact] ([IDContact])
);

